package db;

import java.sql.SQLException;

import java.util.ArrayList;

import model.SubContractor;

public interface IFSubContractor
{
	public SubContractor searchSubContractorID(int subContractorID) throws SQLException;
	public SubContractor searchSubContractorByName(String name) throws SQLException;

	public ArrayList<SubContractor> searchSubContractorEverything(boolean active, String jobName, String search) throws SQLException;
	public ArrayList<SubContractor> searchSubContractorName(boolean active, String jobName, String search) throws SQLException;
	public ArrayList<SubContractor> searchSubContractorEmail(boolean active, String jobName, String search) throws SQLException;
	public ArrayList<SubContractor> searchSubContractorPhoneNo(boolean active, String jobName, String search) throws SQLException;
	public ArrayList<SubContractor> searchSubContractorCity(boolean active, String jobName, String search) throws SQLException;
	public ArrayList<SubContractor> searchSubContractorCountry(boolean active, String jobName, String search) throws SQLException;
	public ArrayList<SubContractor> searchSubContractorAll();
}